Dec 30 2021 08:12 AM
Hello Guys!
Need help here:
I have this formula:=IF(C21="PT",VLOOKUP(G18,'Tab3 *test*'!B5:I41,6,False)
I need to search for different values if C21="PT" (vlookup for one value on a diferent tab) or if C21="US" (vlookup for a another value on a different tab).
How can I merge this?
Thank you!
Dec 30 2021 08:30 AM
@JSCrossAxe
=IF(C21="PT",VLOOKUP(G18,'Tab3 *test*'!B5:I41,6,False),IF(C21="US",VLOOKUP(...),"")
or
=IFS(C21="PT",VLOOKUP(G18,'Tab3 *test*'!B5:I41,6,False),C21="US",VLOOKUP(...),TRUE,"")
