Vlookup on multiple sheets rev2

  • Thread starter Thread starter kellonjames
  • Start date Start date
K

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