-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
HLOOKUP
- Thread starter j4ymf
- Start date
ExcelToDAX
Active Member
- Joined
- Feb 9, 2023
- Messages
- 264
- Office Version
- 365
- Platform
- Windows
How about:
Excel Formula:
=INDEX(FILTER(Lookup!$C$2:$CW$2,Lookup!$C$1:$CW$1=N10),,2)
Upvote
0
Solution
Hello ExcelToDAX
WOW thats works fantastic, thank you
can i just add another tweek please,
im wanting to look for the word "Pattre" and return the value in column 3 and 5 after
=N10),,1) finds the first "Pattre" the value im after is 500
=N10),,2) finds the first "Pattre" the value im after is 270
hope this makes sence
thank you
WOW thats works fantastic, thank you
can i just add another tweek please,
im wanting to look for the word "Pattre" and return the value in column 3 and 5 after
=N10),,1) finds the first "Pattre" the value im after is 500
=N10),,2) finds the first "Pattre" the value im after is 270
VBA Code:
=INDEX(FILTER(Lookup!$C$2:$CW$2,Lookup!$C$1:$CW$1=N10),,2)hope this makes sence
thank you
Upvote
0
