Dear All,
I have two different data where I need to vlookup for if A1=MINC001 AND B1=1-12-14 then bring that column 6
please find attached file for more clarification as I am confuse to explain,
there are multiple lots for same item code I need to bring the quantity from other sheet for that item with same batch, I hope u understand.
Last edited by mubeenff; 12-01-2014 at 04:41 AM.
Rather than VLOOKUP you can use INDEX/MATCH combination:
Formula:
Please Login or Register to view this content.
Never use Merged Cells in Excel
Funny, this VLOOKUP will work too:
Formula:Please Login or Register to view this content.
It's an array function and need to be entered with ctrl+shift+enter (not just enter)
Last edited by zbor; 12-01-2014 at 04:22 AM.
Thanks man, but what if I need in sheet ITEM cell F cost also from sheet AVL cell D4
In E2 write:
Formula:Please Login or Register to view this content.
And extend formula to the right.
That will use next column then.
Re: Vlookup for multiple cell
Thanks Great job dear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks