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!

Conditional Display of Existing Data
Display two columns in data validation list but return only one - Guide
Tmobile data check - Guide
Download mp3 with lyrics display - Download - Audio playback
Huawei display check code - Guide
Gta 5 data download for pc - Download - Action and adventure

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator 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

Unlock safe folder without losing any data

How To Fix Mint Mobile Data Not Working?

Computer turns on but no display

3 beeps no display on monitor

Similar discussions

Subscribe To Our Newsletter!