IF and AND
 

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

IF and AND
 

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