MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Simple LOOKUP problem !


Posted by vaz on November 16, 2000 2:45 AM

Im trying to use a simple Lookup formula to try and find whether the values in column A are in column B and if so give a True,False answer..

A B C
12 13
13 14
14 15
15 16
16 17

So hopefully for C1 it should read "FALSE" and C2:C5 it should read "TRUE"

Can anyone help?


Posted by Loren on November 16, 2000 4:19 AM


try =A1=B1 in cell C1

Posted by vaz on November 16, 2000 4:27 AM

I need it to check throughout the list in column B and need a lookup function for this, dont I? otherwise this =A1=B1 will simply relate the two rows together ???


Posted by Tim Francis-Wright on November 16, 2000 7:08 AM

C1 should have the formula:-
=IF(ISNA(MATCH(A1,$B$1:$B$5,0)),FALSE,TRUE)

You can copy this formula to the other cells in
column C.

HTH!

Posted by vaz on November 16, 2000 7:44 AM

THANKS HTH !!!!!!!

it works!