473,385 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Vlookup function similar like Excel

I need to do the smilar vlookup (Excel function) in SQL command.
Just explain to the below example

Table 1
Store Type Region
AA12 RGS AAA
AA13 REM BBB
AA14 RBK CCC

Table 2
Store Type Turnover
AA12 2345
AA13 7825
AA14 8306

From Table1, I need to take Type column on the basis of Store column and need to paste in Table2 with respective to the Store in table2. Same as excel vlookup function, but I need to do this by using SQL command
Oct 8 '14 #1
1 2197
Rabbit
12,516 Expert Mod 8TB
There's no need to store data twice. Please read our article on normalization to find out why: http://bytes.com/topic/access/insigh...ble-structures.

If you ever need to view the data together, you just need to JOIN the two tables on the key field. If you don't know what this means, please read through this SQL tutorial here: http://www.w3schools.com/sql/.
Oct 8 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Jeff Marcum | last post by:
I need to write a query in Access that returns the results of a text field with the spaces replaced with underscores. So, if the data in the field was 'hello world', the query results would show...
2
by: Franck | last post by:
Hi, Using Add-In project, I can't find how to make my public functions available in Excel ? Thks for help.
4
by: ritheshtitu1982 | last post by:
Hi, I would like to perform Vlookup in access. Eg. I have two Tables Code table Code --- No { ------- 0 ...
1
by: ashwini1680 | last post by:
is there any function in excel to find slope of a straight line iin excel? what's it? Suggest a site or book for studing excel.advance thanks.
1
by: Grubsy4u | last post by:
Hi guys, I know this is a Access Forum but i had an excel question. I wanted to know if anyone knew a way i could delete part of a record for example after the first space. e.g THY0056...
1
by: Mark | last post by:
Hi - is there a function (or does anyone have any code) which replicates the TREND function in Excel: TREND(y, ,newx) I work in a call centre, and would like to predict the grade of service...
0
by: Balaji Gurunathan | last post by:
Hi All, I am exporting a datatable to an excel sheet in an existing workbook. In another worksheet in the same workbook, i am using vlookup function that uses data in the exported worksheet. The...
1
by: BrettHawk | last post by:
Dear Forum, As I'm new to VBA, I was hoping you could answer a VBA / SQL Server 2005 Function question for me. The scenario is this: I am trying to call a SQL Server 2005 Function from...
1
by: TonyRandom | last post by:
I hope I haven't posted this in the wrong section, but it is a VBA problem, so please forgive me if it should be elsewhere. I have two tabs in a spreadsheet, both containing lists of parts codes. I...
1
by: Excelnoobie2013 | last post by:
I currently have a SUMIF function (in Excel) that looks like this (=IF(R1061=0,SUMIF($S$99:$S$19626,S1061,$P$99:$P$19626),. If it helps any it represents this...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.