/*back/*

say "front. lol"

going to mod's office

So I am trying to determine what this particular concept is called in Excel. Say I have a column of numbers (1,2,3,4,5, ...) and on another sheet, I have two columns (1,2,3,4,5,...) and on the same row another cell that has values like (900M,901M, 902M, ...). What is the concept that will allow me to link 900M to 1 from another sheet? Basically I want the 900M number on the first sheet next to 1. There will be values like 905M which will NOT have a correlated number.

I could do this in C# without a problem but would rather do it in Excel if I can (less paperwork)

Just need the concept or the name of the function that will allow me to do that

Answer: XLOOKUP

:-)

....Bummer spoke to soon

Worked in my test...

I ended up getting it working, I had not expanded the lookup far enough into results coloum

Does anyone know if the Windows 11 upgrade will always be free? Or will Microsoft eventually charge for it?

@Michael the windows 10 upgrade apparently still works too

so in theory yes

in practice I doubt

Thanks

No real point in upgrading IMO other than the fear that Microsoft will eventually stop releasing security updates for Win 10.

I think it will always be free, as long as you're updating from a previous version of Windows