Forum Discussion
Pull cells by inputting numbers
Hello, i am not to experienced with excel and am trying to find a formula to pull a cells information into another cell by inputting a number into a 3rd cell. ill give a small example. so if i in...
Using columns A to D, enter the following formula in D2:
=IFERROR(VLOOKUP(A2, B:C, 2, FALSE), "")
or
=XLOOKUP(A2, B:B, C:C. "")
Fill or copy down from D2.
Thank you so much this will help me out and make this so much easier for me. I really appreciate the quick reply.