View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Miree Miree is offline
external usenet poster
 
Posts: 90
Default lookup two columns

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