Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Urgent problem with Vllookup
I need to ASAP to finish my spreadsheet:
I want to do a vlookup on ULTANE STRATEGIC PLANNING to return the value in each row with ULTANE STRATEGIC PLANNING but vlookup only returns the same value 10001069 ULTANE STRATEGIC PLANNING 10001069 ULTANE STRATEGIC PLANNING 10001069-1034-H0 -- Regards, Jeff |
#2
|
|||
|
|||
It may be better to use a filter or sort routine
v lookup will normally only return one value. select the range and go to data filter autofilter click onto the dropdown and select the entry you want filtered. -- greetings from New Zealand Bill Kuunders "Jeff" wrote: I need to ASAP to finish my spreadsheet: I want to do a vlookup on ULTANE STRATEGIC PLANNING to return the value in each row with ULTANE STRATEGIC PLANNING but vlookup only returns the same value 10001069 ULTANE STRATEGIC PLANNING 10001069 ULTANE STRATEGIC PLANNING 10001069-1034-H0 -- Regards, Jeff |
#3
|
|||
|
|||
Thank you Bill,
Is there any way I can do it in Vlookup ? -- Regards, Jeff "bill kuunders" wrote: It may be better to use a filter or sort routine v lookup will normally only return one value. select the range and go to data filter autofilter click onto the dropdown and select the entry you want filtered. -- greetings from New Zealand Bill Kuunders "Jeff" wrote: I need to ASAP to finish my spreadsheet: I want to do a vlookup on ULTANE STRATEGIC PLANNING to return the value in each row with ULTANE STRATEGIC PLANNING but vlookup only returns the same value 10001069 ULTANE STRATEGIC PLANNING 10001069 ULTANE STRATEGIC PLANNING 10001069-1034-H0 -- Regards, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Shared Workbook Problem, Urgent | Excel Discussion (Misc queries) | |||
Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
URGENT Mac/PC macro compatibility problem | Excel Discussion (Misc queries) |