I would like cell D23 to equal the corresponding cell of D4. I'm not sure how to do this. The example I would use is if cell D4 equals 22 (From the "Diameter" table) from the drop down list, I would like cell D23 to automatically equal 10 from the "Bolts" table.
Last edited by Zimmy242; 09-01-2023 at 11:44 AM.
Try this:
=VLOOKUP(D4,$AH$2:$AI$46,2,1)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
This is what i came up with, a bit long and i am self taught in Excel. I have used this on here many times, I went up to where it changed over from 6 to 8
IFS(D4=AH2,AI2,D4=AH3,AI3,D4=AH4,AI4,D4=AH5,AI5,D4=AH6,AI6,D4=AH7,AI7,D4=AH8,AI8,D4=AH9,AI9,D4=AH10,AI10,D4=AH11,AI11,D4=AH12,AI12)
IFS is not an efficient solution here, and this situation is precisely what functions like VLOOKUP, HLOOKUP and XLOOKUP are for - I suggest you have a read up on them. I, too, am completely self-taught.
I will refrain from posting, unless it is a question I have, sorry for the inconvenience.
I did not say that you should not have posted a solution! I offered the informtion to help you improve. Unless, of course, you don't want to learn new and better ways of doing things. You have caused no inconvenience.
Will do, I guess I took the reply wrong, Always looking to learn how to do this stuff without as much typing. I will be looking into the other stuff you listed when I have to make another calc.
Yes, indeed you did. The IFS you offered won't actually work if it's possible for there to be values that fall between those in the lookup table. With my VLOOKUP, the 1 at the end ensures that it will.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks