Vlookup??

[Jamie]

I am compiling a workbook which has several sheets. The first is the main
sheet, the rest contain data whic I need to reference, (a courier companies
rates for example).

I need to be able to check that two cells of the main sheet match (e.g. cell
b1 = "New York" and cell c1 = "[name of courier company]" (as opposed to sea
freight / road freight etc). Then look in cell d1 for the # kilos. I then
need to check [courier rate] sheet for corresponding kilos and then
appropriate rate for that number of kilos, which should be returned as a
value in the main sheet.

I think it is Vlookup, but it's not simple, any ideas please?
Jamie

 

[JMay]

Check out the =Index(RangeToExamine,Row,Column)
the Row (Above) and Column (Above) can be logical Using the
Match() function.

 

[dhstein]

I am compiling a workbook which has several sheets. The first is the main
sheet, the rest contain data whic I need to reference, (a courier companies
rates for example).

I need to be able to check that two cells of the main sheet match (e.g. cell
b1 = "New York" and cell c1 = "[name of courier company]" (as opposed to sea
freight / road freight etc). Then look in cell d1 for the # kilos. I then
need to check [courier rate] sheet for corresponding kilos and then
appropriate rate for that number of kilos, which should be returned as a
value in the main sheet.

I think it is Vlookup, but it's not simple, any ideas please?
Jamie

I'm not completely clear on your request, but Excel formulas will get you
there. Try a test file with some dummy data - all in the same sheet to get
the basic formula. For example ..... =IF (B1 = C1,{true condition goes here
- maybe you do a vlookup}, {false condition goes here} ..... It sometimes
helps when doing complicated formulas to do them in steps - and even set up a
"helper" column with an intermediate step. Anyway, once you have something
that works all in the same sheet, you can modify the formula to use the
correct data from the other worksheet - the syntax requires
OtherWorksheetName!CellReference. Hope it helps a little.