Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Look UP formula by referencing certain values of lookup cell
Hello Dear Friends,
Could you please refer the attached file and help me build a lookup formula that matches certain values of the lookup cell, and also a formula to extract certain values from a destination cell. Any help will be appreciated. Regards, Dumbo |
#2
|
|||
|
|||
Hi Friends
I managed to get the above file solved. But I came across another problem.I had another question regarding lookup by referencing multiple columns. Please refer attached. Can you please advise a solution ? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look UP formula by referencing certain values of lookup cell
Hi,
Am Thu, 13 Nov 2014 04:02:05 +0000 schrieb Excel Dumbo: +-------------------------------------------------------------------+ |Filename: Lookup referencing multiple columns.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=994| +-------------------------------------------------------------------+ in B2: =IFERROR(INDEX($N$3:$N$16,MATCH(A2&C2,$K$3:$K$16&$ L$3:$L$16,0)),0) and insert the array formula with CRTL+Shift+Enter and copy down Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
Referencing a cell where lookup value is not on same row | Excel Worksheet Functions | |||
Lookup Function Referencing cells, not text values | Excel Worksheet Functions | |||
Referencing cell text in a lookup | Excel Discussion (Misc queries) | |||
Referencing 3 values for a lookup | Excel Worksheet Functions |