Hello
Can someone help me to incorporate the correct syntax using VLOOKUP with CHOOSE{} with sheet Reference
Where can i incorporate the 'Sheet3!' in above formula
Formula Entered and Matching Values of G3 and H3 are in Sheet 1 and obtaining data from range is in Sheet3
Thanks and Regards
RapchikM
Can someone help me to incorporate the correct syntax using VLOOKUP with CHOOSE{} with sheet Reference
Excel Formula:
=IFERROR(VLOOKUP(G3&H3,CHOOSE({1,2},B5:B101&C5:C101,E5:E101),2,0),"Not Found")
Where can i incorporate the 'Sheet3!' in above formula
Formula Entered and Matching Values of G3 and H3 are in Sheet 1 and obtaining data from range is in Sheet3
Thanks and Regards
RapchikM