Lookup Question

[carl]

I have a table of data that looks like this:

ColA ColB ColC
OK Buy 20
Sell 10
OK Sell 30



Is it possible to have a formula on another worksheet that
will look at ColA and if it has "OK" as a value, it will
display the values in ColB abd ColC.

Regards.

 

[JulieD]

Hi Carl

in your 2nd worksheet
try =IF(Sheet1!A1="OK", =Sheet1!B1 & " " & Sheet1!C1,"")
where the sheet with the data you gave in the example is called Sheet1 and
where you want the values in cell B1 & C1 to be concatenated.
or
=IF(Sheet1!A1="OK",Sheet1!B1,"")
and
=IF(Sheet1!A1="OK",Sheet1!C1,"")
if you want the result in two separate cells
BTW you don't need to type the Sheet1!A1 bits .. .you can click on these
when you need to use them.

Cheers
JulieD

 

[Aaron]

Say your table below is on "Sheet1",

Enter this function on the new worksheet:
=IF(Sheet1!A1="OK",Sheet1!B1&" "&Sheet1!C1)