Wondering if someone could please help me with this one. I have 2 worksheets. On one worksheet has a number lets say 200 and a space (where I will put some data to be devised). On the other sheet we have the same number to be matched with the one on the 1st sheet. I have a whole range from 2 to 480. Once this is found I need to say if this matches then return me the number i.e 400 in the next cell on the 2nd sheet. I do hope this makes sense.
Have a look at the Vlookup function in Excel's help files..
If you still can't get it, let us know.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks