I'm looking to be able to run a vlookup or something similar that would check if the requested cells value is there but if it is then it should respond by showing the value of a cell from another column rather than the one it's looking at. What's the best way of doing this?
Thinking maybe it would be a combination of vlookup/IFERROR/AND or something along those lines however i'm not sure.
Just to give more insight into this:
I would start my VLookup from I2 selecting A2 as my lookup value and then select column W from another workbook as my table array along with index of 1 and range lookup of false.
This would look like the below.
=VLOOKUP(A2,'[FileName.xlsx]Sheet1'!$W:$W,1,FALSE)
I then want to add onto this that if the vlookup returns true it should return the value of the cell AC2 from the "FileName" workbook which is also in the sheet of "Sheet1"
Is this possible?
Thinking maybe it would be a combination of vlookup/IFERROR/AND or something along those lines however i'm not sure.
Just to give more insight into this:
I would start my VLookup from I2 selecting A2 as my lookup value and then select column W from another workbook as my table array along with index of 1 and range lookup of false.
This would look like the below.
=VLOOKUP(A2,'[FileName.xlsx]Sheet1'!$W:$W,1,FALSE)
I then want to add onto this that if the vlookup returns true it should return the value of the cell AC2 from the "FileName" workbook which is also in the sheet of "Sheet1"
Is this possible?
just to confirm if A2 value is "hello" and the column W from filename.xlsx has a "hello" cell in it would usually return Hello into the cell i entered the formula. I instead want it to return the value from AC2 which for example could be "goodbye" into the cell we put the formula.
