Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with V lookups
I need a formula that based on a cell completes a Vlookup in one worksheet
tab, and if it can not find a value it completes a Vlookup in a different worksheet tab. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with V lookups
=If(ISNA(vlookup1),IF(ISNA(Vlookup2),"No match",vlookup2),Vlookup1)
where VLOOKUP1 and VLOOKUP2 are the VLOOKUP formulae for your two tabs. HTH "Scottinphx" wrote: I need a formula that based on a cell completes a Vlookup in one worksheet tab, and if it can not find a value it completes a Vlookup in a different worksheet tab. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with V lookups
Could do with some more detail, but basically you want something like:
=IF(ISNA(VLOOKUP(to_first_sheet)),IF(ISNA(VLOOKUP( to_second_sheet),"Not Present",VLOOKUP(to_second_sheet)),VLOOKUP(to_firs t_sheet)) VLOOKUP itself takes four parameters, so it might look like this: VLOOKUP(A2,Sheet1!A1:B50,2,0) for the first sheet, and VLOOKUP(A2,Sheet2!A1:B100,2,0) for the second sheet. Obviously, only you can supply the details ... Hope this helps. Pete Scottinphx wrote: I need a formula that based on a cell completes a Vlookup in one worksheet tab, and if it can not find a value it completes a Vlookup in a different worksheet tab. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with V lookups
Scottinphx wrote: I need a formula that based on a cell completes a Vlookup in one worksheet tab, and if it can not find a value it completes a Vlookup in a different worksheet tab. Try using something like this: =IF(ISERROR(VLOOKUP(A!,List,2)),VLOOKUP(A1,List,2) ,VLOOKUP(A1,OtherList,2)) If the first lookup finds no match it returns an error. This results in a true return to the IsError function which tells the IF Function to refer to the VLookup using OtherList. You should be able to change the array names to the ones you are currently using and have it work as you requested. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem understanding dependant lookups | Excel Worksheet Functions | |||
Max and lookups | Excel Worksheet Functions | |||
CAN DATES BE USED IN LOOKUPS? | Excel Discussion (Misc queries) | |||
Maybe I need help with Lookups?? | Excel Worksheet Functions | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |