IF this or this with two VLOOKUPs

New Contributor

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!

1 Reply


=IF(C21="PT",VLOOKUP(G18,'Tab3 *test*'!B5:I41,6,False),IF(C21="US",VLOOKUP(...),"")




=IFS(C21="PT",VLOOKUP(G18,'Tab3 *test*'!B5:I41,6,False),C21="US",VLOOKUP(...),TRUE,"")