LookUp 2 Cells / 1 Table

[Carl]

I have 1 table named Code that looks like so:

ColA ColB
Close 1.00
Filter 2.25
Open 3.25



In my spreadsheet I have data like so:

ColA ColB
Open
Order
Filter
Close

Is it possible to but a formula in ColC that looks at ColA
and ColB and checks if the value is on Table Code and if
it is, returns the ColB of the Table Code ?

Regards.

 

[Frank Kabel]

Hi
try in C1
=IF(A1<>"",VLOOKUP(A1,'sheet1'!$A$1:$B$100,2,0),IF(B1<>"",VLOOKUP(A1,'s
heet1'!$A$1:$B$100,2,0),""))
and copy down

 

[carl]

Thank you again Frank.

I have a formula in A1, do I need to modify the formula ?

Best Regards.

 

[Frank Kabel]

Hi
no it should work also with a formula in A1