No offense meant but that is a pretty bad layout, you could either use
multiple vlookup functions in an if formula, if there are only 6 columns
then that is probably the better choice, otherwise you could use an array
formula like

=INDEX(A1:G3,MIN(IF(B2:G3=I1,ROW(B2:G3))),MIN(IF(B 2:G3=I1,COLUMN(B2:G3)))+1)

entered with ctrl + shift & enter, note that the index part starts in row 1
and column 1, that way you only have to offset for adjacent column to the
right (the + 1)

--
Regards,

Peo Sjoblom


"JR" wrote in message
...

I would like to look up a value in columnns b,d,f etc and return the
corresponiding value in the adjacent column c,e,g

B C D E F G
2 30000 A 30150 b 30300 c
3 30200 a1 30351 b2 30502 b3