I put a formula in cell J3 to look at data in cell A3. If cell A3 is blank then leave cell J3 blank. If cell A3 is not blank, put the data in cell A3 in J3.
This is the formula I used:
=IF(A3="";"";VLOOKUP($A3,EXCEL_ACP,11,FALSE)
I put a formula in cell J3 to look at data in cell A3. If cell A3 is blank then leave cell J3 blank. If cell A3 is not blank, put the data in cell A3 in J3.
This is the formula I used:
=IF(A3="";"";VLOOKUP($A3,EXCEL_ACP,11,FALSE)
Hello feliciauop,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Here is Introduce yourself not Introduce your problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks