I've created an array table with ascending data. I've labeled each row with a specified integer representing length and want to specifically look at a particular row for the closest matching data using HLOOKUP. In the right most column, the first data from top is greater than my minimum search criteria, hence the result returns #N/A. I've created a second statement to correct this when the result = #N/A but cannot seem to tie it to the HLOOKUP function. Any suggestions how to write IF(HLOOKUP)=FALSE,THEN(2ND NON-HLOOKUP FUNCTION)?
HLOOKUP is: =HLOOKUP(BQ4,BK108:BK111,BR4,TRUE)
Where BQ4 = 260 120 amp; BR4 = 1 (statement created to figure row_number)
2nd is: =LEFT(CG4,(SEARCH(" ",CG4))-1)+1amp;" "amp;RIGHT(CG4,(SEARCH(" ",CG4))-1)+1 where CG4 = 208 101 (result = 209 102)
BK108:BK111 = 282 132; 308 150; 337 172; 370 198
Thanks in advance for all suggestion.
Welcome to the MrExcel Board.
=IF(ISNA(HLOOKUP(BQ4,BK108:BK111,BR4,TRUE)),"your other function goes here without the quote marks",HLOOKUP(BQ4,BK108:BK111,BR4,TRUE))Have a great day,
Thanks Stan, this was exactly what I was looking for!