I have a spreadsheet that has a list entery in column A tracking sheet, which is a list on column A of sheet1. Need to have auto fill of info in column B tracking sheet, This is corrisonding info in column B sheet1, if A tracking sheet match A sheet1.
First format column B of the Tracking sheet as General, then use formula:
=VLOOKUP(A3,Sheet1!A:B,2,FALSE)
copied down
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=VLOOKUP(A3,Sheet1!A:B,2,FALSE)
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you all, that worked!!!!!!!!!!!
You're welcome.
If this has answered your question, please mark your thread as SOLVED.
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks