Auto fill cell with $
HI All,
Hoping someone can help, trying to build a small spreadsheet for costs, (sample attached) what i am trying to do is when i add the Abbreviation for the State in column A and the hours in column test.xlsxC, that it auto fills the rate in column D.V2 Test.xlsxV2 Test.xlsx
Last edited by Jams-1361; 12-29-2023 at 03:52 PM.
Try this in D2.
Please Login or Register to view this content.
Convert your range to a table
in B2
=IF([@State]<>"",VLOOKUP([@State],Rates,2,0),"")
where "Rates" is named range for Rate table
New entries will automatically fill column B
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank-you Folks!, the sheet i shared earlier was part of a larger one with more columns (attached for reference), are you saying that i should add the table to another tab and work off of that?
How aboutFormula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks