What formula do I use if I need to look at the column and row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the lookup formula but I need it to look at a value in a
row and in a column example
Cal ID Price 1 Price 2
A125 1.25 1.52
A130 1.22 1.30
A135 1.15 1.35
A140 1.32 1.40
If I need it to look at Just Price 1 cal ID is A130 I need it to return 1.22
but in the next cell I may need it to look at Price 2 A130 and 1.30
 
Hi!

Just use a cell where you enter what price you want:

A10 = lookup_value = A130
B10 = Price # = 1 or 2

=VLOOKUP(A10,A2:C5,B10+1,0)

Biff
 
Back
Top