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
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
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
Thank you so much!

Will try out