Lookup table help

I did this some time ago and have forgotten what I did. I created a medical expense tracking sheet for my girlfriend that incorporates a lookup table. She can merely click the arrow and the medical provider's name is inserted in one cell and mileage is inserted in another. I don't recall if this was a Lookup, Vlookup or other - and don't recall how to access and modify the lookup table. She needs to add/delete some entries and has also moved some entries in the table that now no longer produce the expected results.

Any suggestions? I can attach the small file if it would help.

Duane

Hi and thanks.

I've attached the file. The "Vlookup" table is on the right (n3:o37) and the data selection is made by selecting the medical provider in column B. It then picks the provider name and puts it in column B and the Mileage in column F.

I understand that you need to change the Data Validation from "List" to "Any Value" in the table, make whatever edits on the data, then change it back to "List", putting in the $N$4:$o$39 in column N then $N3:$o$39 into column O. That seems to work (but I don't know where the N4 and N3 comes from).

At any rate, the objective was that she wanted to add/edit data in the (N:O) Lookup table as new providers came and old ones were eliminated or changed. I don't know of a simple way to do this where I don't have to do the Data Validation maneuvers for her as explained above.

I am open (and appreciative) to any suggestions.

Duane

I don't care what they say about you .... I think you're terrific. Thank you for looking at this and all the effort you put into it.

I like the Column A (Active / Inactive) list. Does it do anything to the vlookup table (O:P) or the drop down list in column C ? Or is it merely a label she can use?

For some reason, my column G (Mileage) is not displaying. Instead of the mileage, it is showing #NAME? - is this an error in the formula, my formatting or other?
The formula there is =iferror(VLOOKUP(C24;$O$22:$P$62;2;0);"") - per your comment, is the first blank row 23 or 22?

She wants to "freeze" row 22 so that the header remains as she scrolls thru data. But the summary data you put at the top (which is terrific by the way) only leaves a couple rows of data visible below row 22. Is there a way to move all the summary data to the bottom so the header now in row 22 can be fixed while she scrolls thru the data?

Further info. The #NAME? error in column G (Mileage) occurred while using Open Office on my laptop. When I opened the file in Excel on my desktop, the mileage figures were there.

You are correct. It was nothing bad (that I can say). And yes, I think you have done it .... and done it quite well. Many thanks again. If I can find it, I'll mark this thread as "solved".

regards,
Duane