humanoid769
New Member
- Joined
- Feb 14, 2020
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Hi
I am trying to setup an =IF statement to lookup a value from a certain tab1 within a workbook based upon a field. So if B2=Money Map 1 then go to mony map 1 tab if it is Money Map 2 then read from money map 2 tab if anything else then leave it 0.
I currently have:
=IF(B2="Money Map 1",VLOOKUP(A4,'H:\Downloads\[1b. Pro Tactics BSP Order.xlsm]Money Map 1'!$A$611:$AB$33837,24,FALSE),IF(B2="Money Map 2",VLOOKUP(A4,'H:\Downloads\[1b. Pro Tactics BSP Order.xlsm]Money Map 2'!$A$611:$AB$33837,24,FALSE),0))
But it always returns a 0
Any advice please
Thanks
Tony
I am trying to setup an =IF statement to lookup a value from a certain tab1 within a workbook based upon a field. So if B2=Money Map 1 then go to mony map 1 tab if it is Money Map 2 then read from money map 2 tab if anything else then leave it 0.
I currently have:
=IF(B2="Money Map 1",VLOOKUP(A4,'H:\Downloads\[1b. Pro Tactics BSP Order.xlsm]Money Map 1'!$A$611:$AB$33837,24,FALSE),IF(B2="Money Map 2",VLOOKUP(A4,'H:\Downloads\[1b. Pro Tactics BSP Order.xlsm]Money Map 2'!$A$611:$AB$33837,24,FALSE),0))
But it always returns a 0
Any advice please
Thanks
Tony