IF 1 cell equals a range of others, return this cell

[PDBartlett]

Hello

What would be the formula be for excel to look up 1 cell in a range of others (range = MASTER!T4:CA4) and if it matches any of them, return the value of another cell?

Thanks

[Punnam]

hi ,

Use Vlookup ,Index+Match Functions

Punnam

[PDBartlett]

Thanks but I wouldn't know what the formula would be?

[Punnam]

Hi ,
Provide a sample workbook.

Punnam

[PDBartlett]

It's quite a large workbook so I'll try give you what you need:

The calculation will be in B20 the Depreciation sheet, IF(Investments cell H8 equals any of MASTER range T4:CA4, return cell G8 in the Investments sheet)

[Punnam]

Hi,

=vlookup(b20,H4:CA4,1,0)
Assuming
B20 is th value which are you trying to search
H4:CA4 ,
Column Number 1

Punnam

[estige]

Hi, maybe in B20:
=IF(COUNTIF('MASTER'!T4:CA4,'Investments'!H8)>0,'Investments'!G8,"No match")

[PDBartlett]

Punnam, that didn't return the value of cell G8

Estige, that works perfectly!! Thanks so much

[Punnam]

hi,

May be problem in choosing the column number try it once with different numbers.

Punnam