If cell is blank vlookup and if not blank do another vlookukp

[PIEAGUI11]

The formula I am using right now is =IF(M533="",(VLOOKUP(N533,Sheet3!A:D,2,FALSE)),(VLOOKUP(M533,Sheet3!A:D,2,FALSE)))
I will either enter info into M533 or N533. If I have no info in M533 and I do put info in N533 I need to have the vlookup pull the info tied to that cell.

 

[DanteAmor]

And what problem do you have with the formula.


You can use it like this:

=VLOOKUP(IF(M533="",N533,M533),Sheet3!A:D,2,0)