Hello,
I need help making a shorter formula of this one:
=IF(C3="Presiune Nominala";Values!E3;IF(C3="Presiune Mare";Values!F3;IF(C3="Presiune Mica";Values!G3;IF(C3="Temperatura Nominala";Values!B3;IF(C3="Temperatura Mare";Values!C3;IF(C3="Temperatura Mica";Values!D3;IF(C3="Debit Normal";Values!H3;IF(C3="Debit Mare";Values!I3;IF(C3="Debit Mic";Values!J3;0)))))))))
Values! represents a different page.
I am a beginner in excel..
Thanks
Hi DeamonX,
welcome to the forum.
Try using below formula:-
Formula:
=INDIRECT(VLOOKUP(C1,$H$1:$I$9,2,0))
where H1:I9 would contain a table showing different values of C3 and which sheet's value to be picked, if matched, see the below attachment to understand better
shortened formula.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
It worked, thanks.
Great
Please mark this thread as [SOLVED].. Thanks.
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks