LinkBack URL
About LinkBacks
I have 2 Excel 2010 spreadsheets and I want to take the Patients from #1 spreadsheet and pull them from #2 spreadsheet by the patient # also pulling the charges and collections.
I have 2 Excel 2010 spreadsheets and I want to take the Patients from #1 spreadsheet and pull them from #2 spreadsheet by the patient # also pulling the charges and collections.
Try using a VLOOKUP. For instance, if you have Sheet1 and Sheet2, and Sheet1 has the patients' information, on Sheet2 in B1 (with the patient #'s running down column A), type:
=VLOOKUP(A1,Sheet1!A:C,2,0)
and drag it down.
Is that a start?
That did not work. I have been trying different ways of VLOOKUP and either I am just doing it wrong or that is not the way to do what I need to do.
VLOOKUP is definitely the way to go; you just need to know how to use it.
Maybe post a copy of your sheet (without any sensitive information) and we can try to help
Based on the very small amount of information you are giving I would say try the function VLOOKUP. Make sure the last parameter is a zero and lock the lookup range with $.
Edit: Hmm... some funny time warp here
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
you can try index and match. but a sample will be great for us to understand more
Regards,
Hyperdude
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks