Real_Sooner
New Member
- Joined
- May 20, 2019
- Messages
- 1
I have a sheet named 'Diff' that has ID in column A and Difference in column K.
I have another sheet named 'Udata' that has ID in column A and amounts in columns B:JG.
I am trying to look up the code in row 3 (column header) of the UData tab, based on the ID number and Difference from the Diff tab, but keep getting the error N/A. Help Please!
Example:
Diff Tab
A167964 = 1234
K167964= 5.22
Udata tab
A4 = 1234
BG3 = SSHT-R
BG4 = 5.22
Need a formula for cell L167964 on the Diff tab that gives me a result of "SSHT-R"
BONUS: What if there are 2 or more columns in B:JG that have the number 5.22? Is there a way to get multiple results? Thanks in advance!
I have another sheet named 'Udata' that has ID in column A and amounts in columns B:JG.
I am trying to look up the code in row 3 (column header) of the UData tab, based on the ID number and Difference from the Diff tab, but keep getting the error N/A. Help Please!
Example:
Diff Tab
A167964 = 1234
K167964= 5.22
Udata tab
A4 = 1234
BG3 = SSHT-R
BG4 = 5.22
Need a formula for cell L167964 on the Diff tab that gives me a result of "SSHT-R"
BONUS: What if there are 2 or more columns in B:JG that have the number 5.22? Is there a way to get multiple results? Thanks in advance!