lookup two columns

  • Thread starter Thread starter Miree
  • Start date Start date
M

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
 
Miree,

Something like:

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

HTH,
Bernie
MS Excel MVP
 
Back
Top