I want to look up items in columns A and B in Sheet 1. I want to find the two items in columns A and B in Sheet 2 and return the result found in column C in Sheet 2.
Not sure if I need a Vlookup or Index & Match formula. Got myself a little muddled!
Any help really appreciated.
thanks
If you're muddled - you're in good company, 'cos we can't see what you want. Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
EXAMPLE DATA.xlsx
See attached file.
In the Product sheet, I want to be able to match a combination of the PRODUCT and CITY fields to the PRODUCT and CITY fields in the CUSTOMER sheet and return the ACCOUNT NUMBER.
thanks for your help so far.
I've fixed it.
{=INDEX(CUSTOMER!A2:E30, MATCH(1, (A2=CUSTOMER!A2:A30) * (C2=CUSTOMER!D2:D30),0), 3)}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks