Two way lookup on a table from user input

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

I have a table that lists my different specs in column one. I want a formula
that will read the spec that is keyed in by the user and then also read the
spec gravity number keyed in by the user and then look up the spec column and
follow that row across until it comes to the column with the user entered
spec gravity number. At this intersection, there will be a number that is
needed to figure pounds of material.
 
Try this:

...........A..........B.............C..............D.....
1................SpGr1......SpGr2......SpGr3
2....ABC.......20............30.............40
3....DEF........10............20............30

To lookup DEF SpGr2:

F1 = DEF
G1 = SpGr2

=VLOOKUP(F1,A1:D3,MATCH(G1,A1:D1,0),0)
 
Back
Top