| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use vlookup function in more than one table same time
i want to use vlookup function in a table but my main data is in two
different tables. Is it possible what I use a macro for it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i use vlookup function in more than one table same time
Assuming you have named your tables table_1 and table_2, then you can
use this formula: =IF(ISNA(VLOOKUP(A1,table_1,2,0)),IF(ISNA(VLOOKUP( A1,table_2, 2,0)),"absent",VLOOKUP(A1,table_2,2,0)*),VLOOKUP(A 1,table_1, 2,0)) Where A1 contains the value you are trying to match. I've assumed you want to bring data back from the second column of the tables if you find a match, and if there is no match in either table you will get the word "absent". Hope this helps. Pete On May 18, 2:44 pm, Sanjeev kumar <Sanjeev wrote: i want to use vlookup function in a table but my main data is in two different tables. Is it possible what I use a macro for it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does the vlookup function not work using time? | Excel Worksheet Functions | |||
| How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| vlookup function in excel referencing an access table | Excel Worksheet Functions | |||
Hybrid Mode
