Hi,
Have searched all over this forum and Google and can't seem to find an answer that actually works.
I am trying to write a forumula in Excell 2010, which (and I hope this makes sense) If the text in a dropdown menu in a cell is High then it references the answer from a formula on a different worksheet, if not then references a 2nd answer.
Hope that makes sense, any help much appreciated.
Thanks
Maybe you could post a sample workbook so we can see where the drop down box is, what the options are, where they're picked up from, etc.Hope that makes sense
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Something like:
Formula:
Please Login or Register to view this content.
You're going to have to be a lot more specific though, if you want a more specific solution. Attach a workbook, show what your required outcome looks like.
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,
=IF(dropdown_cell_ref="High",different_worksheet_name!this_cell_ref,otherwise_this_cell_ref)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks