Forum Discussion
Can we use VLookup to fill in fields from Scattered Data ?
Hi, I wanted to know that is it possible to use VLookup to fill in data in a certain row by matching it from different rows rather than just from a single row. In the attached image, I want to ...
I tried both methods but none of them is able to pull the values of Pink & Yellow. In the first method, the value is always coming to be "2500" and in the second method it's only filling in "TRUE" and no the value.
P.S. - I'm attaching the file where the problem is. Please have a look at it and tell me if you have a way to solve it.
Thank You in advance.
I don't know why do still use the wrong VLOOKUP() and get a mixture of two formulas in one column.
There has to be only one formula in the column. Put in H2 and copy it down.