Find the closest number in a column and bring back the corresponding number in another col

**tho_kva2** · 02-28-2020, 10:18 PM

Hi,
I hope this makes any sense, sorry if it doesn't, then I'll try to explain it a little better.
"Test" and explanation of what I'm looking for are in the sheet.

It's more or less to find the closest number in a column and bring back the corresponding number in another column.

Thanks in advance!

**mehmetcik** · 02-29-2020, 07:44 AM

if your data was variable then your formula for B3 would be =VLOOKUP(B2,AA:AD,4)

However your data is predictable. So all you need is =index(AD4:AD64,B2)

Find the closest number in a column and bring back the corresponding number in another col

LinkBack

Thread Tools

Rate This Thread

Display

Find the closest number in a column and bring back the corresponding number in another col

Re: Find the closest number in a column and bring back the corresponding number in another

Thread Information

Users Browsing this Thread

Similar Threads

Find duplicate number in same list, and bring back name

[SOLVED] Bring back certain number of characters before a particular letter or number

[SOLVED] Find value that doesn't match and bring back column heading

[SOLVED] right find to bring back only a number

[SOLVED] Formula to bring back a number if X is Y or Z

Reference 4 cells and bring back a single number (including solved dummy file)

Bring Back Multiple Items Based on Common Number

Bookmarks

Bookmarks

Posting Permissions