LookUp 2 Cells / 1 Table

  • Thread starter Thread starter Carl
  • Start date Start date
C

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.
 
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
 
Thank you again Frank.

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

Best Regards.
 
Back
Top