Vlookup on multiple sheets rev2

[kellonjames]

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

 

[RAGdyer]

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.

 

[Sandy Mann]

Hi RD,

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

--
Regards,


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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[RAGdyer]

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>

 

[Sandy Mann]

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

Good hunting.

--

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[RAGdyer]

No problem whatsoever.

My pleasure.