| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ?
Works OK for me.
Excel creates the named range "Extract" when you do the filter operation. You can just delete that defined name. Goto InsertNameDefine Select Extract Delete OK Then your VLOOKUP formula should work: =VLOOKUP (A10,B$4:C$8,2,FALSE) -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ?
Hi Biff,
Thanks for the tip. Best Regards Low -- A36B58K641 "Mr. Low" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Hi Biff, Thanks for the tip. Best Regards Low -- A36B58K641 "Mr. Low" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
