Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Match Formula

Hi,

Im looking for some match formula/lookup for the attached ss.

I want to match the data in "Raw Data" and "Output" based on Cell (B2) [Highlighted Red].
Any rows that match in "Raw Data" get returned where cells are highlighted green.

So what im trying to do is bring back data from "Raw Data" where the ISIN is the same as in "Output"

Thanks
Seamus
test.zip
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Paste this in N2

=IF(ISERROR(VLOOKUP(M2,'Raw Data'!$A$1:$I$163,2,0)),"",VLOOKUP(M2,'Raw Data'!$A$1:$I$163,2,0))

O2

=IF(ISERROR(VLOOKUP(M2,'Raw Data'!$A$1:$I$163,3,0)),"",VLOOKUP(M2,'Raw Data'!$A$1:$I$163,3,0))

P2

=IF(ISERROR(VLOOKUP(M2,'Raw Data'!$A$1:$I$163,4,0)),"",VLOOKUP(M2,'Raw Data'!$A$1:$I$163,4,0))

and so on...

Just increase the BOLD and UNDERLINE number by 1

Sid
ASKER CERTIFIED SOLUTION
Avatar of krishnakrkc
krishnakrkc
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi,

To trap the error,

=IF(ISNUMBER(MATCH($B2,'Raw Data'!$A$2:$A$163,0)),INDEX('Raw Data'!$B$2:$I$163,MATCH($B2,'Raw Data'!$A$2:$A$163,0),COLUMNS($N2:N2)),"")

If you are using XL 2007,

=IFERROR(INDEX('Raw Data'!$B$2:$I$163,MATCH($B2,'Raw Data'!$A$2:$A$163,0),COLUMNS($N2:N2)),"")

Avatar of Seamus2626

ASKER

Thanks guys, il go with the match.

Thank you very much

Cheers
Seamus