Forum Discussion
Solved
IF and Lookup Function
Hi Guys, I have sheets. Sheet "Vehicle Register" and "Trucks". In the "Vehicle Register" sheet I have registration numbers in column A and Vehicle Type in column B. I need to on the "Trucks" ...
=IFERROR(INDEX('Vehicle Register'!$A$2:$A$5,SMALL(IF('Vehicle Register'!$B$2:$B$5="Truck",ROW('Vehicle Register'!$1:$4)),ROW('Vehicle Register'!1:1))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
If you have Excel 2019 or later you can apply FILTER function.
=IFERROR(INDEX('Vehicle Register'!$A$2:$A$5,SMALL(IF('Vehicle Register'!$B$2:$B$5="Truck",ROW('Vehicle Register'!$1:$4)),ROW('Vehicle Register'!1:1))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
If you have Excel 2019 or later you can apply FILTER function.
You are a legend. This did exactly what I wanted it to do! Thanks