Miree,

Something like:

=VLOOKUP(F21,Densities!C:D,2,False) & ": " & VLOOKUP(F21,Densities!G:H,2,False)

HTH,
Bernie
MS Excel MVP


"Miree" wrote in message
...
I have two long tables with nanes and numbers next to them

Is there a way to look up both tables in the same formula

The names colums are C and G
The numbers columns are D and H
The tables are on a seperate worksheet Densities
Looking up what is in cell F21