Hi sir,
I have creating a workbook using function vlook. but only manage to handle search in 2 criteria.
=IF(ISERROR(VLOOKUP(C2,Sheet1!$B$2:$T$10000,3,0)),VLOOKUP(C2,Sheet1!$C$2:$T$10000,2,0),VLOOKUP(C2,Sheet1!$B$2:$T$10000,3,0))
Anybody know the formula to search for 3 criteria based ?
below workbook may assist you in understanding my request
Please and Thanks
Hi,
I have updated the formula in Name field (cell C6) in the attached file & it works fine for 3 columns. Please modify the same for other cells.
maybe
Formula:
Please Login or Register to view this content.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Pl see attached file
This also works
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 08-07-2014 at 07:35 AM.
PLease, Can anyone help me on this issue ?http://www.excelforum.com/excel-form...n-2-table.html
Re: VLookup for 3 criteria
Got the solution..
My formula..
Formula:Please Login or Register to view this content.
check the attachment..
Don't forget to click *
HI Vikas Can you help on my thread @ http://www.excelforum.com/excel-form...n-2-table.html
luckyvasul
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Hi Vikas,Originally Posted by Vikas_Gautam
Got the solution..
My formula..
Formula:Please Login or Register to view this content.
check the attachment..
Don't forget to click *
Your formula code is work cool using function INDEX. But could you teach / explain me the function of "LARGE" & "(ROW($D$3:$D$612)-2),1))"
Thank Bro.
Sorry for replying so late..
Actually I used (ROW($D$3:$D$612)-2) to return the row no. of the cells matching criteria..
I have deducted 2 to correct row no.s to correspond the the rows in the index provided..
Then I used Large Function to return the 1st largest Row no....
Use FORMULA AUDITING on a SMALLER EXAMPLE to understand it better..
Don't forget to click *
Last edited by JBeaucaire; 08-29-2014 at 12:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks