Not really sure whats wrong. Its hard for me to explain it. VLOOKUP only populates data correctly from the first instance of the formula. Attached a test document that shows what I'm looking at. Pull a "spell" from the list and the following cells should populate with the spells statistics. I'm not super familiar with Excel macros so I'm probably missing something stupid.
Thanks for any help.
test.xlsm
Hi Poisontoast,
You can use the below formula:-
Formula:
Please Login or Register to view this content.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi dilipandey,
Thanks that works. Quick question though. Why does it work lol, or better question why was my original macro only working for the "cost" column. I only ask because I'm trying to lean how this all works. Thanks again for your quick response!
Hi poisontoast,
Earlier it was not working because you have not followed the syntax of vlookup correctly..
Also, there is no macro only formulas are used there.
Regards,
DILIPandey
<click on below 'star' if this helps>
Understood. Thanks again dilipandey!
You are welcome ...
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks