IF and AND

[phil2006]

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

 

[CLR]

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

hth
Vaya con Dios,
Chuck, CABGx3