Vlookup

CustomGT · Mar 24th 2006

i know a few formulas now and know something about macros, but im going nutz here trying to get this simple dang vlookup to work...
ive messed with it for 2 hours....

i tried it on 2 computers thinking maybe the settings were wrong nope...

please help lol

carlmack · Mar 24th 2006

Re: Vlookup

Your range should be A:C. You would also be better off using False in the last part and making the range more specific eg A1:C3

HTH

andyjw · Mar 25th 2006

Re: Vlookup

this formula will work for you

=IF(ISNA(VLOOKUP(A:A,Sheet2!A:C,3,FALSE)),"Not in list",VLOOKUP(A:A,Sheet2!A:C,3,FALSE))

Vlookup

Participate now!

Share