Find out the target cell value
Hi,
I want to find the specific value in the row of a specific text. Eg. I paste in the left (A1:G20) a pack of information, in the right, I want to find the score of "TDSR, Credit ratio and Net exposure" by clicking the commandbutton "Find the score".
If one commandbutton is not feasible, is that possible to make 3 commandbuttons to get the 3 values?
BOOK1 Riso.png
Last edited by joejiang2001; 12-30-2014 at 01:45 PM. Reason: Thank you Excellent experts Kenneth Hobson and davesexcel
After the latest update to Excel, forms and activex controls can show errors. Microsoft put out a short fix one can download until they can fix it in another update.
For now, you can see how this would work.
Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
Or
Please Login or Register to view this content.
Last edited by davesexcel; 12-30-2014 at 01:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks