lookup two columns

[Miree]

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

 

[Bernie Deitrick]

Miree,

Something like:

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

HTH,
Bernie
MS Excel MVP