View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heather Heather is offline
external usenet poster
 
Posts: 148
Default Lookup with 2 columns of data to match

Hi!

I have 2 columns of data that need to be looked up in a reference table

For example
Column A Column B Result
A .25 100
B .27 150

The result column is being fed by a reference table matching up Column A & B
... and we don't want to add Columns A & B together because their are numbers
actually in there and want to keep them separate

can anyone help??? Thank you!!!