Hi guys,
i have tried using mirror function but i can't seem to get what i want.
Example: i need to have a set of fixed data on sheet1 and a blank sheet2
sheet1 contains 2 column say column A1 with ''A'' B1 with ''1'', A2 with ''B'', B2 with ''2'' and so on.
so when i go to sheet2 to key in any either A or B in column A, i will be able to pick the right number associated with the fixed data.
Really hope i am able to find the right coding if possible.
Thanks all in advance.
Last edited by excel2891; 08-13-2011 at 01:46 AM.
Hi,
You can use this code.
You insert it in to the sheet2 code, not a module.
Steffen Thomsen
Please Login or Register to view this content.
Hi'
In B! cell of sheet2 enter the formula and drag it below as much required.
=VLOOKUP(A1,Sheet1!$A$1:$B$4,2,FALSE)
where $A$1:$B$4 represents the range used in sheet1.
I hope it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks