Microsoft Office Questions? Ask a IT Expert for Support ASAP
Yes most likely a VLOOKUP formula will do it (or an INDEX/MATCH formula depending on the data)
Please send me the file so I can set up the formula on it. To do so go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
What I want to do is in spreadsheet 1, use a formulae in E35 to E48 to read the names of an employees in Column A35 to A48, then go to speadsheet 2 and match the names and then go in the corresponding row in Column DH and return the number to the corresponding name. Thanks
Thanks. Can you give me the correct names of the two sheets
Check out this screenshot. The formulas are in the yellow cells
If that's what you're looking for I will send you the file with the formulas
Thank you very much, this is exactly what I was looking for.Please send formula.
Great. I am preparing the final file now, in the meantime you can go ahead and rate if that is the solution you're looking for
Thanks. Much appreciated
One moment, uploading the file.....
Ok here you go
Again the formulas are in the yellow cells
Hope this is ok. Let me know if you have any questions