Without more specific information..........I would imagine the VLOOKUP
function would probably do what you want.........

hth
Vaya con Dios,
Chuck, CABGx3



"phil2006" wrote in
message ...

Hi,

I need a formula that will put the value from the relevant row into a
grid.
I have on sheet 1 a chart with place names in colums 2 and 4 with
corresponding relevant information in column 1. On sheet two I have a
grid. I need a formula that will insert the value from column one into
the boxes where the grid matches the columns.

Thanks,

Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=557602