PDA

View Full Version : Using VLookup in Excel



Tenspeed39355
10-31-2012, 06:00 AM
Here I go again. I have two ss. The first one contains the data I want to extract to the second ss. Here is the VLookup I am using to extract the data =VLOOKUP(A3,'C:\users\max parris\desktop\[NAV.xlsm]Sheet2'!$A$1:$B$28,2,0) I have in the second ss in column A all the stock symbols. The vlookup command is in column B. In the first ss in column A I have the symbols. Here is the problem I am having. When I use vlookup it goes to the first ss and retreves the data from the ss but it is the data that is in column B. Example the fist symbol is COY. VLookup goes to the first ss and retreives the data from COY in column B. I need the data that is in column B28. The symbol that is in A28 is not COY. COY is in A10. What I am asking vlooup to do is take the simbol is the second ss AOD go to the first ss, lookin column A find AOD then go to column B28 and retreive what is in B28. I think I am in a mess. Is VLookup the command I need to use.

Thanks for any help on this one.

Max:banghead:

Bob Phillips
10-31-2012, 08:21 AM
If you always want B28, why not just =B28 with the appropriate sheet prefix?

Tenspeed39355
10-31-2012, 10:13 AM
xld Thanks for the quick reply. I have tried a formula like this one but I am getting an error message. What am I doing wrong?
=VLOOKUP(A3,[NAV.xlsm]Sheet2!,=$B$28)

Bob Phillips
10-31-2012, 01:32 PM
That formula is just wrong, wrong syntactically, wrong logically.

I was suggesting forgetting VLOOKUP, and just reference the cell that you want. But I concede I may have completely missed what you are trying to do.

Tenspeed39355
10-31-2012, 02:30 PM
Here is the best way I can explain what I am after. I want the first symbol in spreadsheet 2 col A to find the symbol in spreadsheet 1 column A. If it is
ANYWHERE in col A then go to B28 in spreadsheet 1 and send that data back to the second spreadsheet in column B3. When vlookup finds the symbol in ss one it will not be in A28. There will be times it will be in A10.
That is where the problem is. The symbol wil be disconnected from B28.
Thanks again.

Bob Phillips
10-31-2012, 03:51 PM
Then maybe

=IF(ISNA(MATCH(Sheet2!A2,Sheet1!A:A,0)),"",Sheet1!B28)

Tenspeed39355
11-01-2012, 05:11 AM
Hi XLD I ran the above and it works. Thanks for your help. I will rate this
thread.
Max