View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louja Louja is offline
external usenet poster
 
Posts: 17
Default Multiple variable lookup tables

I have a slightly different query now.

This is a sample of my table

FTSE LEUR LESF
BRH Futures 0.03 0.03 0.03
CTSL 0.04 0.04 0.04
GH Kapital 0.06 0.06 0.06
Northern Spark Trading 0.04 0.04 0.04
James Sullivan Group 0.05 0.05 0.05
TDT 0.04 0.04 0.04
Triniti 0.03 0.03 0.03
Paragon 0.03 0.03 0.03

If I wanted to look at FTSE for BRH Futures is it best to do a list:

CTSL FTSE 0.04
TDT LEUR 0.04 etc

If the top way is easier - how would I do the formula?

Thanks for all your help so far.