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.
|