Excel Quaries

This query is : Resolved

Goongan (Querist)
Follow

05 February 2010 Columm A Column B
6,359.00 2,686.00
6,373.00 9,667.00
9,667.00 8,465.00
8,465.00 6,359.00
2,296.00 3,205.00
2,436.00 2,540.00
6,139.00 5,017.00
3,696.00 4,253.00
4,574.00 1,068.00
1,767.00 1,078.00
2,686.00 2,296.00
2,645.00
3,205.00
2,540.00

we want to reconcile each Amount in Column B with Column A
if same amount of Column A found in Column B result True other wise false

Which Formula We should Use …

CA Shishir

CA Shishir (Expert)
Follow

05 February 2010 Put values in col A and col B, paste this forumla in col C. You can change the selection range depending on the number of rows

=IF(VLOOKUP(B1,$A$1:$A$16,1,0)>0,TRUE, #N/A)