Traveltime
New Member
- Joined
- May 21, 2018
- Messages
- 17
I hope someone can assist with this, it's probably fairly basic. I'm a beginner with formulas so any help is very much appreciated.
This is what I'm trying to accomplish:
If the text in AN equals one of the text values in a separate column, then I want to enter the cell to equal the text in cell AN, if not I want the cell to equal the text in cell C.
This formula works for the true statement, but I receive "#N/A" for the false statement.
=IF(AN2=(Vlookup(AN2,F2:F32,1,false)),AN2,C2)
<colgroup><col width="199" style="width: 149pt; mso-width-source: userset; mso-width-alt: 7082;">
<tbody>
</tbody>
This is what I'm trying to accomplish:
If the text in AN equals one of the text values in a separate column, then I want to enter the cell to equal the text in cell AN, if not I want the cell to equal the text in cell C.
This formula works for the true statement, but I receive "#N/A" for the false statement.
=IF(AN2=(Vlookup(AN2,F2:F32,1,false)),AN2,C2)
Array Table: Sub Expense Type-draft (Keep) |
Airport Fee |
Parking |
Other Ground T |
Baggage Fees |
Airfare |
Rail |
Taxi/Car Servi |
Tolls |
Airfare |
Hotel |
Hotel Tax |
Hotel Deposit |
Car Rental |
Fuel |
Miscellaneous |
Tips |
Expense Distribution |
Transport |
Transportation |
Passengers |
Immunizations/ |
Meals - Overni |
Meals - Same D |
Personal - Cor |
Travel Suspense |
Entertainment |
PA Vouchers |
NC Catering |
PA Catering |
AZ Catering |
AZ Vouchers |