In column A1 is my pay rate.
In column A2 is my car count.
In column A3 is my type service.
I want A1, A2 and A3 to all be recongized for the answer.
Example:
In A1 I have the letter B
In A2 I have the number 50
In A3 I have the letter L
With these 3 contents in the cells, I need a answer of 100.
NOW;
If I change A1 to the letter C
If I leave A2 at 50
If I change A3 to F
I would like the answer to be 200
I can do the regular Index function ok. I understand the tables.
It's this third item in column A3 I am having a problem with(I think).
I hope this is enough information without getting real deep in the
formula.
Thanks in advance for any help.