Help with variables in cells

[BAZ47]

I am just starting out with VBA & I'm sinking fast!
I am hoping that there is someone out there who can offer some help with the following.
I have variable values in each cell of 3 columns (6 variables per cell in col1,2 variables per cell in col2 & 2 variables per cell in col3. Based on what is shown in each cell of those columns I then need to display a value (shown in a cell on another worksheet) in each cell of column 4.
Hopefully a solution is possible with VBA.
Thanks in advance.

 

[Peter_SSs]

Welcome to the MrExcel board!

A few sets of sample data and the corresponding results may well help clarify what you are after.

 

[BAZ47]

Thanks for the welcome Peter.

ITEM GRADE COUNTRY DELIVERY
APPLES 1 MEXICO YES
BANANAS 2 CUBA NO
CHERRIES 3 GUYANA
CUCUMBERS
BEANS
APRICOTS

Above is the type of data I'm dealing with. What I am trying to do is similar to using an IF function.
eg.
IF(A2="CHERRIES", IF(B2=1, IF(C2="CUBA",D2)))
Where ITEM could be any 1 of 6
GRADE could be any 1 of 3
COUNTRY could be any 1 of 3
The result in the DELIVERY column would depend on the entries in the other cells.

Hope that's clearer.

 

[Peter_SSs]

Hope that's clearer.

Not much I'm afraid. From what I can see your data is set out like below. (You might want to investigate the screen shot methods suggested in my signature block so you can show screen layout better).

Excel Workbook
	A	B	C	D
1	ITEM	GRADE	COUNTRY	DELIVERY
2	APPLES	1	MEXICO	YES
3	BANANAS	2	CUBA	NO
4	CHERRIES	3	GUYANA
5	CUCUMBERS
6	BEANS
7	APRICOTS
8
BAZ47

But what you want to do with this data is not clear. You gave the example ..

IF(A2="CHERRIES", IF(B2=1, IF(C2="CUBA",D2)))

.. but I can't see how the result D2 flows from the data if A2, B2 and C2 held those values. Why isn't the result D3 or something else?

Also what would you want the formula to return if the conditions are not met.

You might need to fill us in some more on what you are really trying to achieve in your sheet.

 

[BAZ47]

You're right, my explanation is quite poor & not really what I meant! I think I will go back to the "drawing board" & start over. Thanks for your advice, it's appreciated.