Return cell based on another cell help!

  • Thread starter Thread starter Mintyman
  • Start date Start date
M

Mintyman

Hi,

I have a spreadsheet with a list of codes in column A, a Master list of
codes in column C, and a Master description in D that is associated with the
values in C.

If a code exists in A, I would like to check if the same code exists in C.
If so, I would like to populate column B with the description in D.

Can anyone show me how to do this please?
 
Try this in B1:

=IF(ISNA(MATCH(A1,$C$1:$C$100,0)),"No Match",VLOOKUP(A1,$C$1:$D$100,2,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi,

I have a spreadsheet with a list of codes in column A, a Master list of
codes in column C, and a Master description in D that is associated with the
values in C.

If a code exists in A, I would like to check if the same code exists in C.
If so, I would like to populate column B with the description in D.

Can anyone show me how to do this please?
 
Back
Top