I am trying to do an IF statement with a VLOOKUP and it is giving me an error. The syntax would be =IF(Logical TEST, If True, If false).
So......
=IF(VLOOKUP([@Column1],US_UPC,1,FALSE) = [@Column1],VLOOKUP([@Column1],KR_UPC,1,FALSE),"False")
Also, is it possible to have several Logical Tests?
We would need to see a asmple of what you are working with. Could it be that the 1st vlookup if returning an error?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
What value are you trying to look up. If you upload the workbook maybe we can advise further.
And yes you can have many logical test but above half a dozen or so formulae become hard to read and understand quickly.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks