Vlookup on multiple sheets rev2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kellonjames@gmail.com - 22 Nov 2007 18:58 GMT

=IF(ISNA(VLOOKUP($A1,Sheet1!A:F,2,0)),IF(ISNA(VLOOKUP($A1,Sheet2!A:F,
2,0)),"not present",VLOOKUP($A1,Sheet2!A:F,2,0)),VLOOKUP($A1,Sheet1!
A:F,2,0))

the avove formula return the data on sheet two but not on sheet one.
if any one knows how to tweek it please help.

Reply to this Message

RAGdyer - 22 Nov 2007 22:47 GMT

Your formula is fine!

You should check your data on Sheet 1 to make sure that it matches the type
of data you're entering into A1.

Try *manually* entering a value in A1, and *manually* enter the exact same
data somewhere in Column A of Sheet1 and you should receive a valid return.

If you're importing data, there's a good chance that there might be imbedded
spaces or various other invisible characters included with the import.
If numbers are involved, a numeric and text number, although similar in
appearance, do *not* produce a match.

Signature

HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------

> =IF(ISNA(VLOOKUP($A1,Sheet1!A:F,2,0)),IF(ISNA(VLOOKUP($A1,Sheet2!A:F,
> 2,0)),"not present",VLOOKUP($A1,Sheet2!A:F,2,0)),VLOOKUP($A1,Sheet1!
> A:F,2,0))
>
> the avove formula return the data on sheet two but not on sheet one.
> if any one knows how to tweek it please help.

Reply to this Message

Sandy Mann - 22 Nov 2007 23:07 GMT

Hi RD,

OT but bs there any significance in your changing from RagDyeR to RAGdyer?
Personally I thought that RagDyeR looks better.

Signature

Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Your formula is fine!
>
[quoted text clipped - 17 lines]
>> the avove formula return the data on sheet two but not on sheet one.
>> if any one knows how to tweek it please help.

Reply to this Message

RAGdyer - 23 Nov 2007 13:15 GMT

You probably didn't notice, but I use many different forms of my handle.

The placement of the uppercase letters tell me where I was (at which
machine - at what plant) when I sent them.

It allows me to know where my test sheets may be stored, just in case a
thread becomes complicated and /or spans a long time period.
In some cases I'll e-mail the test sheet to myself in order to be able to
continue a thread when I know I'll be away from a certain location for a
while.

This is an uncommon form due to the fact I'm on vacation and doing some
hunting in up-state New York.

Didn't really think that anyone noticed my placement of capitals.<bg>

Signature

Regards,

RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------

> Hi RD,
>
[quoted text clipped - 22 lines]
>>> the avove formula return the data on sheet two but not on sheet one.
>>> if any one knows how to tweek it please help.

Reply to this Message

Sandy Mann - 23 Nov 2007 19:30 GMT

Thank you RD, I didn't mean to pry <g>

Good hunting.

Signature

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> You probably didn't notice, but I use many different forms of my handle.
>
[quoted text clipped - 37 lines]
>>>> the avove formula return the data on sheet two but not on sheet one.
>>>> if any one knows how to tweek it please help.

Reply to this Message

RAGdyer - 23 Nov 2007 21:41 GMT

No problem whatsoever.

My pleasure.

Signature

> Thank you RD, I didn't mean to pry <g>
>
[quoted text clipped - 41 lines]
>>>>> the avove formula return the data on sheet two but not on sheet one.
>>>>> if any one knows how to tweek it please help.

Reply to this Message