Two way lookup on a table from user input
 

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.


--
Kim

Two way lookup on a table from user input
 

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)


--
Biff
Microsoft Excel MVP


"Kim" wrote in message
...
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.


--
Kim