Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup
Hi guys, hopefully someone can help with this. I'm using this function below: =LOOKUP(C3,DATASHEET!$A$2:$A$111,DATASHEET!$F$2:$F $111) Which works fine, it compares C3, to a new sheet, then grab the appropriate column value in "F". Now what I want to do it take C3 AND D3 on sheet1, then on the next sheet (DATASHEET) find matching in the list for 2 Columns, say ColumnA AND Column B. Then return the value in ColumnF. Any ideas???? Thanks, Stephen -- Solarissf ------------------------------------------------------------------------ Solarissf's Profile: http://www.excelforum.com/member.php...o&userid=34834 View this thread: http://www.excelforum.com/showthread...hreadid=549595 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup
Try...
=INDEX(DATASHEET!$F$2:$F$111,MATCH(1,IF(DATASHEET! $A$2:$A$111=C3,IF(DATAS HEET!$B$2:$B$111=D3,1)),0)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , Solarissf wrote: Hi guys, hopefully someone can help with this. I'm using this function below: =LOOKUP(C3,DATASHEET!$A$2:$A$111,DATASHEET!$F$2:$F $111) Which works fine, it compares C3, to a new sheet, then grab the appropriate column value in "F". Now what I want to do it take C3 AND D3 on sheet1, then on the next sheet (DATASHEET) find matching in the list for 2 Columns, say ColumnA AND Column B. Then return the value in ColumnF. Any ideas???? Thanks, Stephen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |