i`m a newbie at excel so please forgive me.
this might be easy it might not
I need to do the following...
i have done a lot of basic programming so i will try to explain it that way
i will input 4 numbers in lets say A1-D1
lets say 1-2-3-4
down below in the sheet i will copy a bunch of numbers from an online table
and paste the in sheet.
lets say
22 44 66 88
45 46 72 54
14 44 58 16
and lets say they are pasted into A3-D5 So A3=22 B3=44 C3=66 D3=88 A4=45 ect.ect ect.
I will name each cell like oneone onetwo onethree or whatever
now since my first input is 1(A1) and my second is 2(B1) i need my cell to say
if A1=1 and B1=2 then the value of this cell = the value of onetwo
hope this makes sense.I think i just confused myself. not even sure if its even possible but thanks for looking
sheet attached
Bookmarks