Previous Topic Next Topic

Conditional Display of Existing Data

Solved/Closed
DeathByExcel - 21 Mar 2012 à 04:23
 DeathByExcel - 22 Mar 2012 à 18:45
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 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
22 Mar 2012 à 10:45
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
22 Mar 2012 à 18:45
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
No display on monitor, light blinks
Harsh20_4 -
Anonymous -

9 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses