Webform Woes

so_tx_anglerette

We are using a Webform for "Check In" and "Check Out" but only the "Check Out" captures the "Installation Status". Each "GVRID" has 1 of each. We need the "Check In" "Installation Status" to match what is entered during "Check Out" for the same GVRID. The Webform is a source sheet and feeds a master via "INDEX MATCH". INDEX MATCH returns the first value it finds. If it "finds" the "Check In" first, it returns a null value. We need it to return the "Check Out" "Installation Status". Worked on this for hours and can't figure it out. Appreciate your help.

Webform.jpg

Paul Newcome

You would use an INDEX/COLLECT to filter out blanks.

=INDEX(COLLECT({Range To Pull}, {Range To Pull}, @cell <> "", {Match Range}, @cell = [Column Name]@row), 1)