Lookup and Reference
I am using the lookup function to find similar values in two different
columns and am able to get the desired results. However when I want to bring the value of a third column in to match the results of my lookup matched column I can not make that work. I have tried to nest functions (offset, lookup, if), any suggestions. A B C D E 1 810410 810410 810410 443 443 2 810413 810413 810413 1243 1243 3 910200 910200 910200 0 0 4 920311 910300 920311 0 40984 5 920353 920311 0 40984 NA Column A represents the values needed, Column B represents the values available, Column C represents the values that were matched using LOOKUP, column D represents the values tied to the original column B available values. I need a formula to create a column E that will line up the column D values with the column A values as shown above. -- Thanks, Al |
All times are GMT +1. The time now is 09:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com