Hi Everyone,
I'm wondering if there is a way to populate a DLookup in a cell based on the population of another cell in the same row?
For example, Cell D2 is populated with a Scan as text. When that happens I would like to populate cell H2 with the formula below and then repeat that in each row as cells column D are populated.
=IFERROR(VLOOKUP(G2,GAMES!$A:$B,2,FALSE),0)
Thank you!
Something like this perhaps in sheet module...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks