Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff
 
Posts: n/a
Default 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   Report Post  
bill kuunders
 
Posts: n/a
Default

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   Report Post  
Jeff
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
Shared Workbook Problem, Urgent calimari Excel Discussion (Misc queries) 2 July 8th 05 07:48 PM
Urgent Urgent Urgent!!! Ruslan Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 06:33 PM
URGENT Mac/PC macro compatibility problem marika1981 Excel Discussion (Misc queries) 7 January 8th 05 01:43 AM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"