Can someone please help me correct this vlookup formula in the attached workbook? I need the vendor name from 'Sheet 1' to align with the Item ID (Column 1; 'Sheet'), which is the vendor code.
Thank you!!
Christina
Can someone please help me correct this vlookup formula in the attached workbook? I need the vendor name from 'Sheet 1' to align with the Item ID (Column 1; 'Sheet'), which is the vendor code.
Thank you!!
Christina
Formula for B2 =VLOOKUP(A4,Sheet1!$A$2:$D$500,2)
The IDs in Sheet1 must be sorted numerically smallest to largest.
This is a better solution.
B2 =INDEX(Sheet1!$A$2:$D$500,MATCH(A4,Sheet1!$A$2:$A$500,0),2)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks