Using vlookup on two worksheets

Right now I am using vlookup To lookup a name in one worksheet. I
would like to look for that name in two different worksheets.
Specifically to look for a matching name in the first worsheet and if
you don't find it look in the second worksheet.

Here is the function I am using now. I suspect I will have to use
nested if functions but nothing is working right.


=IF(C4500="","",VLOOKUP(C4500,WOOKSHEET1!A:E,3,FALSE))


Thank you,

Steve

Hi Steven

something along the lines of
=IF(C4500="","",IF(ISNA(VLOOKUP(C4500,WORKSHEET1!A:E,3,0)),VLOOKUP(C4500,WORKSHEET2!A:E,3,0),VLOOKUP(C4500,WORKSHEET1!A:E,3,0)))

Cheers
JulieD

"Steven Robilard" <[email protected]> wrote in message
news:[email protected]...
> Right now I am using vlookup To lookup a name in one worksheet. I
> would like to look for that name in two different worksheets.
> Specifically to look for a matching name in the first worsheet and if
> you don't find it look in the second worksheet.
>
> Here is the function I am using now. I suspect I will have to use
> nested if functions but nothing is working right.
>
>
> =IF(C4500="","",VLOOKUP(C4500,WOOKSHEET1!A:E,3,FALSE))
>
>
> Thank you,
>
> Steve

=IF(C4500="","",IF(ISNA(VLOOKUP1),"",VLOOKUP1,IF(ISNA(VLOOKUP(2),"",VLOOKUP2
,and so on

Howevere there is a limit of 7 nested functions so unless you haven't got
more than a few sheets I would recommend that you download Laurent Longre's
Morefunc from here

http://longre.free.fr/english/

then after installing it use a function called THREED as follows

=IF(4500="","",VLOOKUP(C4500,THREED(Sheet1:Sheet30!A1:E1000),3,0))

--

Regards,

Peo Sjoblom



"Steven Robilard" <[email protected]> wrote in message
news:[email protected]...
> Right now I am using vlookup To lookup a name in one worksheet. I
> would like to look for that name in two different worksheets.
> Specifically to look for a matching name in the first worsheet and if
> you don't find it look in the second worksheet.
>
> Here is the function I am using now. I suspect I will have to use
> nested if functions but nothing is working right.
>
>
> =IF(C4500="","",VLOOKUP(C4500,WOOKSHEET1!A:E,3,FALSE))
>
>
> Thank you,
>
> Steve

Thank you Julie. It worked great.


On Fri, 11 Feb 2005 23:34:34 +0800, "JulieD"
<[email protected]> wrote:

>Hi Steven
>
>something along the lines of
>=IF(C4500="","",IF(ISNA(VLOOKUP(C4500,WORKSHEET1!A:E,3,0)),VLOOKUP(C4500,WORKSHEET2!A:E,3,0),VLOOKUP(C4500,WORKSHEET1!A:E,3,0)))
>
>Cheers
>JulieD
>
>"Steven Robilard" <[email protected]> wrote in message
>news:[email protected]...
>> Right now I am using vlookup To lookup a name in one worksheet. I
>> would like to look for that name in two different worksheets.
>> Specifically to look for a matching name in the first worsheet and
if
>> you don't find it look in the second worksheet.
>>
>> Here is the function I am using now. I suspect I will have to use
>> nested if functions but nothing is working right.
>>
>>
>> =IF(C4500="","",VLOOKUP(C4500,WOOKSHEET1!A:E,3,FALSE))
>>
>>
>> Thank you,
>>
>> Steve
>

Just for fun. This will also work:

=LOOKUPV(C4500,WORKSHEET1!A:E,3,0,LOOKUPV(C4500,WORKSHEET2!A:E,3,0,""))

Just copy this code: http://tinyurl.com/6o95h


Ola Sandstrom

you're welcome and thanks for the feedback

"Steven Robilard" <[email protected]> wrote in message
news:[email protected]...
> Thank you Julie. It worked great.
>
>
> On Fri, 11 Feb 2005 23:34:34 +0800, "JulieD"
> <[email protected]> wrote:
>
>>Hi Steven
>>
>>something along the lines of
>>=IF(C4500="","",IF(ISNA(VLOOKUP(C4500,WORKSHEET1!A:E,3,0)),VLOOKUP(C4500,WORKSHEET2!A:E,3,0),VLOOKUP(C4500,WORKSHEET1!A:E,3,0)))
>>
>>Cheers
>>JulieD
>>
>>"Steven Robilard" <[email protected]> wrote in message
>>news:[email protected]...
>>> Right now I am using vlookup To lookup a name in one worksheet. I
>>> would like to look for that name in two different worksheets.
>>> Specifically to look for a matching name in the first worsheet and
> if
>>> you don't find it look in the second worksheet.
>>>
>>> Here is the function I am using now. I suspect I will have to use
>>> nested if functions but nothing is working right.
>>>
>>>
>>> =IF(C4500="","",VLOOKUP(C4500,WOOKSHEET1!A:E,3,FALSE))
>>>
>>>
>>> Thank you,
>>>
>>> Steve
>>
>