Forum Discussion

Hael34's avatar
Hael34
Copper Contributor
Dec 16, 2021

Nested IF function or???

Hello,  I am trying to create a time sheet that will populate the invoice amount. I have several drop down lists on another tab to choose certain info from that will populate on the first tab. I wou...
Formulas and Functions
mathetes's avatar
mathetes
Gold Contributor
Dec 16, 2021

Hael34 

 

You're right that being able to attach a file would be the most helpful, but there are safeguards in place so that brand-new users can't inadvertently upload a virus-infected file.

 

SO...my sense is that you'd be better served by using a table of the various values that might apply to Ft. Myers, or Sanibel, or Cape Coral (or whatever your various locations are). 

Then use VLOOKUP or one of the other lookup functions.

 

Let me refer you first to this website where VLOOKUP is explained. https://exceljet.net/excel-functions/excel-vlookup-function

 

If that isn't sufficient (or doesn't seem to fit) let me invite you to come back and, in the absence of the actual worksheet, describe more fully what is going on, what value(s) are associated with different locations, etc. With that information,  I or or one of the other experts here could create a spreadsheet to demonstrate how it works.......

Resources