Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLOOKUP wrong?
Hey all, I've got 2 columns "A" has names & "B" has percentages. I've
been able to use the VLOOKUP function w/in the same workbook as the data with success, however when I try to make a new workbook using VLOOKUP I can't get the formula to work. Here's what I thought the formula should look like: =VLOOKUP([Number.xls]Sheet1!$A$2:$A$500="JACK",Number.xls!Test, 2,FALSE) Can someone please point out my idiocy & get me set on the right track? Thanks a ton :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP gets wrong value | Excel Discussion (Misc queries) | |||
Vlookup derived wrong value | Excel Worksheet Functions | |||
vlookup, what am I doing wrong? | Excel Discussion (Misc queries) | |||
VLOOKUP returning wrong row | Excel Worksheet Functions | |||
What wrong with VLOOKUP formula | Excel Worksheet Functions |