| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sequential VLookups
You're welcome!
"Motaad" wrote: Thank you .... it worked...not sure why .... but it did :-) -- Motaad "Teethless mama" wrote: "rng1" is a define name range A10:K10 "rng2"...................................O10:Y 10 "rng3"...................................AA10: AK10 =VLOOKUP(A3,IF(COUNTIF(rng1,A3),rng1,IF(COUNTIF(rn g2,A3),rng2,rng3)),3,0) If it doesn't find in one of those three ranges, it returns #N/A "Motaad" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookups | Excel Discussion (Misc queries) | |||
| Vlookups | Excel Discussion (Misc queries) | |||
| Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
| vlookups | Excel Worksheet Functions | |||
| Sequential names on Sequential pages | Excel Worksheet Functions | |||
Threaded Mode
