hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
In workbook2 I am doing vlookup to get values from workbook1 (Sheet1). Criteria is: If the value in the Col_index_num is null or #N/A then I want value from another column.
Ex:
Workbook1
A1=PPP-100 B1=PETER C1=#N/A
Workbook2
A1=PPP-100
D1 (output where formula is required)=vlookup(A1,Table_array,3,0) is giving #N/A (C1) but then I require B1 i.e. Answer=PETER
How to accomplish?
Ex:
Workbook1
A1=PPP-100 B1=PETER C1=#N/A
Workbook2
A1=PPP-100
D1 (output where formula is required)=vlookup(A1,Table_array,3,0) is giving #N/A (C1) but then I require B1 i.e. Answer=PETER
How to accomplish?