View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default 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