Previous Topic Next Topic

Conditional Display of Existing Data

Solved/Closed
DeathByExcel - Mar 21, 2012 at 04:23 AM
 DeathByExcel - Mar 22, 2012 at 06:45 PM
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!
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Mar 22, 2012 at 10:45 AM
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
DeathByExcel
Mar 22, 2012 at 06:45 PM
Thank you so much!

Will try out

Similar discussions

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses