This may or may not be an IF statement. I have a spreadsheet with 2 Worksheets. Worksheet 1 is called Work, Worksheet 2 is called Data.

WORK has cells Q16, R16 and S16 filled with data that is automatically entered through a formula from a different part of the cell.

DATA has just a table of data with no formulas.

What I need is if in the WORK worksheet Q16, R16 and S16 are populated with numbers $500,000 to $$749,000 then I need it to grab from cells B10 and C10 in the DATA worksheet and somehow copy those cells then go back to the WORK worksheet and enter that info into the Y5 and Y6 cells in the WORK worksheet.

Here's where it becomes difficult. If the numbers in Q16, R16 and S16 are $750,000 to $999,999 then I need it to grab from B11 and C11 in the DATA worksheet.

Can anyone help?