Index Match function for multiple linked variables
I have a worksheet that has 6 columns of numerical data that all column
datasets are referenced together for each row. So for example the data in row 5 in all colums is related. Column C through F have 4 numbers that refer to the data in the first 2 columns. These are also ordered by row. I need to look in column A for 0.00, and column B for 3.14 Both of these must be in the same row or I need the closest value. When these values are found in columns A & B, return the values from the same row in Columns C through F. Thanks in advance, Bob |
All times are GMT +1. The time now is 08:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com