Return Lookup Value from another Tab after looking up 3 columns ??

[daleholden]

How do i return the correct value in excel via a lookup
Problem
Tab Stock
Col A = Item Number e.g 1001
Col J Return Value from Look UK

Tab Shipping
Col A = Item Number e.g 1001
Col G = UK Shipping Cost for item 1001

So i want

Tab Stock

Item Shipping Cost
1001 9

Tab Shipping

Item NL BE DE FR UK
1001 5 6 5 8 9

Hope it makes sense how do i return 9 from Tab Shipping back to Tab Stock ?

 

[gorem]

I could be misunderstanding your need, but would entering =VLOOKUP(A2,Shipping!A:F,6,FALSE) into cell J2 on Stock work for you?

 

[daleholden]

HI i have tried the following


=VLOOKUP(A15,'(5) DROP SHIP CHARGES'!A4:A,7,0)

Also tried =VLOOKUP(A15,'(5) DROP SHIP CHARGES'!A4:U226,7,FALSE) covering the whole table

I get #N/A

Note A15 is correct it is where the codes start

 

[daleholden]

Hi Guys

I sorted it chers