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.
Thank you!
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.
Thank you!
Code:
=IFERROR(VLOOKUP(G2,GAMES!$A:$B,2,FALSE),0)
Last edited:
