Hi!

I need to look in column A for 0.00, and column B for 3.14 Both of
these must be in the same row or I need the closest value.

Closest value to which? Closest to zero in column A or closest to 3.14 in
column B?

Can you post an example and a more detailed explanation?

Biff

"Bob" wrote in message
oups.com...
I have a worksheet that has 6 columns of numerical data that all column
datasets are referenced together for each row. So for example the data
in row 5 in all colums is related.

Column C through F have 4 numbers that refer to the data in the first 2
columns. These are also ordered by row.

I need to look in column A for 0.00, and column B for 3.14 Both of
these must be in the same row or I need the closest value. When these
values are found in columns A & B, return the values from the same row
in Columns C through F.

Thanks in advance,

Bob