| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ?
Hi,
I use Advance Filter to get unique reference in a table by output it to A10: A16 : A B 10 XB12 =VLOOKUP (A10,B$4:C$8,2,FALSE) 11 LH24 =VLOOKUP (Extract,B$4:C$8,2,FALSE) 12 NB47 13 VB45 14 NP96 15 TR45 16 MN32 After that I would like to search data for column A reference from table B4:C8, However I could not enter formula=VLOOKUP (A10,B$4:C$8,2,FALSE) at B10, The word "Extract" is replacing the lookup cell A10 instead. May I know why and how to overcome this problem ? Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: How to extract characters ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to extract data from columns ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to extract references from a list ? | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
Threaded Mode
