Conditional Display of Existing Data

Solved/Closed
Report
-
 DeathByExcel -
Hello,





I am trying to find a way to perform the following without Macro but met with much difficulty.

If Cell A1=Any value available in Column B (e.g. B3), Cell A2 would display corresponding value shown in Column C of the same row (e.g. C3).

Impossible?

Please help!

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi DeathByExcel,

Use the following formula in A2:
=VLOOKUP(A1,B:C,2)

or
=IF(ISERROR(VLOOKUP(A1,B:C,2,0)),"",VLOOKUP(A1,B:C,2,0))


Best regards,
Trowa
0
Thank you so much!

Will try out
0