GOOD DAY. I am a dummy in excel and programming. in the workbook i have attached, in Template! $G2 i want that when a user enters 1, the formula looks up the value for 1 in LISTS!B7 and replaces the 1 with the value in B7. same goes for if users enters 2, 3, 4, 5. if any other number it should give an error message.
I would really appreciate your help on this
Thank you
a vlookup or index match formula would usually accomplish something like that, the problem is that you cannot have both a value "1" and a formula in a cell at the same time.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I have tried the Vlookup formula, is not working what i want. perhaps there is no such way to achieve this. i will have to try and learn programming
Hey there,
Right clcik "TEMPLATE" tab>>view code>> paste this code there-
Check attached.
Please Login or Register to view this content.
Try entering a number in column G.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
thank You this part is solved. I am studying the macro now
2. on the same worksheet is it possible to have a formula that searches in another workbook for an exact match of B2 and returns the ID number in C2
You can use Vlookup for the same.
Check this link - http://www.extendoffice.com/document...-workbook.html
This shows you how you can use vlookup between 2 workbooks.
If you face any problems in implementing the formula do ask.
Thank you sourabhg98. i have used the following formula
=IFERROR(VLOOKUP(TRIM($B2),'[Activity Attendance Register Template v3 Blank.xlsx.xlsm]Registration'!$A$2:$J$24559,1,FALSE),VLOOKUP(MID(TRIM($B2)&" "&TRIM($B2),FIND(" ",TRIM($B2))+1,LEN(TRIM($B2))),'[Activity Attendance Register Template v3 Blank.xlsx.xlsm]Registration'!$A$2:$J$24559,1,FALSE))
but it returns a #N/A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks