| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup combined with Match formulas???
What I am trying to do is take one figure from sheet 'MMS report' which is D2
and then match that text and alpha field (it would be something like 122345E) to a an exact match in column C from sheet 'EORI report' and then return a field from further along that row (column 9) The formula i have tried to enter is as follows can anyone spot what i am doing wrong as this is not returning a correct result? VLOOKUP('MMS Report'!D2,(MATCH('MMS Report'!D2,'EORI report'!C2:C296,1)),9,FALSE) I have tried this with changing the Vlookup to a Hlookup but with the rest of the formula the same in case i was misunderstanding it. Any guidance given would be much appreciated. -- Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining MATCH & LOOKUP formulas | Excel Worksheet Functions | |||
| string lookup combined with SUM | Excel Worksheet Functions | |||
| IF and lookup functions combined? | Excel Worksheet Functions | |||
| vlookup and match combined? | Excel Worksheet Functions | |||
| ISNA(MATCH...) and IF functions - can they be combined? | Excel Worksheet Functions | |||
Threaded Mode
