Seamus2626
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
To trap the error,
=IF(ISNUMBER(MATCH($B2,'Ra w Data'!$A$2:$A$163,0)),INDE X('Raw Data'!$B$2:$I$163,MATCH($B 2,'Raw Data'!$A$2:$A$163,0),COLUM NS($N2:N2) ),"")
If you are using XL 2007,
=IFERROR(INDEX('Raw Data'!$B$2:$I$163,MATCH($B 2,'Raw Data'!$A$2:$A$163,0),COLUM NS($N2:N2) ),"")
To trap the error,
=IF(ISNUMBER(MATCH($B2,'Ra
If you are using XL 2007,
=IFERROR(INDEX('Raw Data'!$B$2:$I$163,MATCH($B
ASKER
Thanks guys, il go with the match.
Thank you very much
Cheers
Seamus
Thank you very much
Cheers
Seamus
=IF(ISERROR(VLOOKUP(M2,'Ra
O2
=IF(ISERROR(VLOOKUP(M2,'Ra
P2
=IF(ISERROR(VLOOKUP(M2,'Ra
and so on...
Just increase the BOLD and UNDERLINE number by 1
Sid