Having a mental block! Help appreciated!
I need to match Ref & Ref1 and return Value to the corresponding Result cell.
I need to exclude errors i.e.#Div!0, #N/A
NOTE: Ref & Ref1 values can be out of sequence.
Match.jpg
Having a mental block! Help appreciated!
I need to match Ref & Ref1 and return Value to the corresponding Result cell.
I need to exclude errors i.e.#Div!0, #N/A
NOTE: Ref & Ref1 values can be out of sequence.
Match.jpg
Last edited by Bravo33; 11-19-2012 at 05:47 AM. Reason: Insert image
try in d2
=IF(ISNA(MATCH(A2,$C$2:$C$200,0)),"",INDEX($D$2:$D$200,MATCH(A2,$C$2:$C$200,0)))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Martin,
Unfortunately for some reason did not work, keep getting " " result.
well since you only posted an image its kind of hard to tell what's in the cells!
Last edited by martindwilson; 11-19-2012 at 07:01 AM.
Point taken.
Please find enclosed spreadsheet.
Cheers
Use this in cell B2 and drag down:
Formula:Please Login or Register to view this content.
Hope this helps
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
works fine here is your workbook back (kbkumar =IF(A2="","",INDEX(D:D,MATCH(A2,C:C,FALSE),)) will give #n/a if a value exists in col a but not c)
Many thanks, I took your "try in d2" as formula in d2.
Thanks for your help!!
@ Martin Wilson: Agree...
and i apologise it was a typo d2 should have been b2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks