Thread
:
VLookup
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Mary Lou[_2_]
external usenet poster
Posts: 21
VLookup
i think i got the formula to work!
"JP Ronse" wrote:
Marie-Lou,
Try
if(isna(vlookup[first]), vlookup[second],vlookpup[first])
It is a bit cryptic, the idea is if the first vlookup returns an error, use
the second, if it doesn't use the first.
Hope this helps
Wkr,
JP
"Mary Lou" <Mary
wrote in message
...
I have a vertical lookup which is pulling information from another
worksheet
within the same workbook. I want to be able to have the formula look in
worksheet #1 and if it does not find it in that worksheet - go to
worksheet
#2 and do the same vertical lookup.
Can someone help me format this? Thanks!
Reply With Quote
Mary Lou[_2_]
View Public Profile
Find all posts by Mary Lou[_2_]