Trying to figure out how to do a VLOOKUP function or combination of functions to identify a value on a table using two paramaters.
Here is a string of data:
Ven ID Site ID Ins Ref Site ID Ins Ref Site ID Insurance Ref
1221 8393 21 7768 12 9399 29
2113 8493 34 6364 87 3349 54
4395 6362 88 8372 41 8393 28
3993 3382 62 9549 63 7629 39
2214 9399 82 3382 91 8492 19
9849 9549 76 1121 24 4382 20
So want to be able to input values:
3993 and 3383 and have it return 62 (value in the next column after 6364).
Note - 3383 may exist in other rows, but the value after will be different and the location or column will be different.
Thank you for the help!
Bookmarks