Posted to microsoft.public.excel.misc

shakey1181

Posts: n/a

LOOKUP Question

When using V or H lookup, is there anyway to get the function to return the
reference for the second occurence of what it is looking for? So, I am
looking for the number 23, but it appears tiwce on the sheet and it is the
second one I need.

If that makes any sense, thanks in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Help using lookup function	Blackbird	Excel Discussion (Misc queries)	9	December 19th 05 11:40 PM
Another way to lookup data	David Vollmer	Excel Worksheet Functions	1	September 23rd 05 05:16 AM
Lookup Type Question	carl	Excel Worksheet Functions	1	March 8th 05 08:30 PM
Formula Question... LookUP	G	Excel Discussion (Misc queries)	4	March 7th 05 01:38 AM
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM

All times are GMT +1. The time now is 03:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us