• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 110
  • Last Modified:

Matching cells in two worksheets

Good Day Experts,

I have two worksheets in the same workbook called Nitrostat 03312014. I would like to match the cells in worksheet Unique Members 4804 in column B with the title header name Claim Identifier cells A9:A4138 with those in the same workbook, worksheet Member Claims A3473:5968.  Can you assist?  Thank you.
0
Beeyen
Asked:
Beeyen
1 Solution
 
NBVCCommented:
I think you will need a sort of INDEX/MATCH or VLOOKUP formula, but I am trying to wrap my head around your description.

I am thinking something like this in your Unique Members 4804 sheet.

=INDEX('Member Claims A3473:5968'!$B:$B,MATCH(B2,'Member Claims A3473:5968'!$A:$A,0))

This will look for the value you have in B2 of the Unique Members sheet and find it in column A of the Member Claims A3472:5968 sheet.  If it finds it it returns respective item from column B.  Otherwise you get an #N/A error.

The error can be hidden with IFERROR

e.g.

=IFERROR(INDEX('Member Claims A3473:5968'!$B:$B,MATCH(B2,'Member Claims A3473:5968'!$A:$A,0)),"")

Is that close?  If not, can you describe further?
0
 
BeeyenAuthor Commented:
Considering my explanation Sage did a very good job of answering my question
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now