Happy Friday All!
Below is a simple table of data that I need help with. In my real sheet Column A has over 7,000 Items. Column D (Col C is blank) has about 400. I am trying to figure out a formula that will Search column A for a match in Column D, then return the value of Column B in Column E. The red numbers indicate the end result that I am looking for. I have tried using the following formula but something is wrong: =if(match(D3:D5,A3:A5,0)B3:5,""). Am I close or am I really far off?
Thanks for the help.
<tbody>
</tbody>
Below is a simple table of data that I need help with. In my real sheet Column A has over 7,000 Items. Column D (Col C is blank) has about 400. I am trying to figure out a formula that will Search column A for a match in Column D, then return the value of Column B in Column E. The red numbers indicate the end result that I am looking for. I have tried using the following formula but something is wrong: =if(match(D3:D5,A3:A5,0)B3:5,""). Am I close or am I really far off?
Thanks for the help.
A | B | C | D | E |
Sold VIN | AGE | Purchased VIN | AGE | |
FMJ | 32 | RQR | ||
LUT | 67 | FMJ | 32 | |
CCW | 99 | LUT | 67 |
<tbody>
</tbody>