Posted to microsoft.public.excel.worksheet.functions

Motaad

external usenet poster

Posts: 20

Sequential VLookups

I have a spreadsheet that has three tables. I need to create a lookup that
looks in the first table and if it doesn't find the value goes to the second
table and then the third to find the value. What I have been using is

vlookup(a3,a10:k10,3,vlookup(a3,o10:y10,3,vlookup( a3,aa10:ak10,3,0)))

and it's not working. Any ideas.
--
Motaad

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
vlookups	T	Excel Discussion (Misc queries)	4	May 13th 06 12:15 PM
Vlookups	Shaya M	Excel Discussion (Misc queries)	3	May 27th 05 07:17 AM
Non-sequential VLOOKUP function -OR- sequential sort of web query	Eric S	Excel Worksheet Functions	1	February 28th 05 07:50 PM
vlookups	Valerie S.	Excel Worksheet Functions	0	January 28th 05 12:55 AM
Sequential names on Sequential pages	Salt4	Excel Worksheet Functions	2	November 12th 04 04:24 PM

All times are GMT +1. The time now is 01:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us