Extending a nested IF function.

W

Wanderer

I need to use several functions like this:
IF(B1=C1,C3,IF(B1=D1,D3,IF(B1=E1, E3, IF....)))))))))))) Or however many I'd
need (hundreds on each example of this).

Is there really no way to say: If the value = the column heading, use the
value from that column?

Seems like that would be pretty common.
 
D

daddylonglegs

In this case you could use HLOOKUP, depending on the extent of your
headers

=HLOOKUP(B1,C1:Z3,3,0)
 
Top