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

PIEAGUI11

New Member
Joined
Jul 24, 2019
Messages
1
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.
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,950
Messages
5,525,827
Members
409,665
Latest member
Jessyi

This Week's Hot Topics

Top