Take a quick look at my spreadsheet. I'm trying to figure out how to have a price rate inserted into a specific cell, based on a date that is entered, and whether that date falls within a certain range...it's way easier to look at the spreadsheet to be able to understand what I'm trying to say. There's explanations in the spreadsheet as well (inserted as cell comments).Rates.xls
In cell H3, enter:
Formula:
=VLOOKUP($H$2,$B$3:$D$6,3,TRUE)
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi waterwings and welcome to the forum,
Look at http://ezinearticles.com/?VLOOKUP-Tr...ith&id=3870922
for a full answer.
See if the attached helps.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks