| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup in one table if no data look in another
I have a rather large workbook with dozens of pages and I'm having trouble
with a vlookup that I would appreciate help with. What I need is for one table (with 2009 data) to be looked at and if there's no value then to look at another table (with 2008 data). The formula I came up with, that doesn't work if there's no 2009 data, is: =IF(VLOOKUP($B$94,ALG09Data,4,FALSE),VLOOKUP($B$94 ,ALG08Data,4,FALSE),VLOOKUP ($B$94,ALG09Data,4,FALSE)) B94 has the value I'm looking for. I would appreciate any help. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200812/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup With Multiple Instances in Data Table | Excel Worksheet Functions | |||
| VLOOKUP not working due different formats in lookup data & table? | Excel Discussion (Misc queries) | |||
| vlookup data in a dynamic pivot table? | Excel Worksheet Functions | |||
| vlookup fails on data from a pivot table | Excel Worksheet Functions | |||
| Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
Threaded Mode
