Hi Guys,
Need your help with a dynamic vlookup between two tables/sheet.
Table ABC
Type Select Value Output
White Bread 1 20
Brown Bread 2 20
Table XYZ (holds value)
Type Value 1 Value 2
Bread White Bread 20.00 10.00
Bread Brown Bread 40.00 20.00
The formula i have is =VLOOKUP($A2,XYZ!$A$1:$D$10, MATCH(ABC!B$2,XYZ!$C$1:$D$1,0)+2,0)
Help is appreciated!
Here is one suggestion...
=INDEX(XYZ!$B$2:$C$3,MATCH("Bread "&$A2,XYZ!$A$2:$A$3,0),MATCH($B2,XYZ!$B$1:$C$1,0))
On Table XYZ...
B2 = 1
C2 = 2
versus how you had it...
B2 = Value 1
C2 = Value 2
If you want the Value with the number, then use a custom format on B2 and C2 >> "Value "0
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks