DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,968
I am setting up a table for shipping costs on sheet 2. I want to pull the cost over when it matches the item and method of shipping.
Item is Shoes, Method is Ground, Cost is $8.00.
Sheet2 Organization is:
A1= Item
B1= Method
C1= Cost
Values:
A2= Shoes
B2= Ground
C2= $8.00
My formula is:
=VLOOKUP(A2:A10,Table!C2:C10,3,true)
I receive a #Value error.
thanks,
Doug
Item is Shoes, Method is Ground, Cost is $8.00.
Sheet2 Organization is:
A1= Item
B1= Method
C1= Cost
Values:
A2= Shoes
B2= Ground
C2= $8.00
My formula is:
=VLOOKUP(A2:A10,Table!C2:C10,3,true)
I receive a #Value error.
thanks,
Doug