hi - Need help with understanding hwo to return a cell reference based on
values in the cell...here are some details...any help would be absolutely
appreciated.

User Input Form

Type Name Rev $ No of Stores State
Retail Reece 12 300 VIC
Retail Big W 1222 212 NSW
Retail JB 1212 232 SA
Retail Target 3234 343 WA

Database Table
Type Name Rev $ No of Stores State
Retail Reece C2 D2 C2
Retail Big W C3 D3 C3
Retail JB C4 D4 C4
Retail Target C5 D5 C5

RowCount (needs to look up the database table which has Company Type and
House Name and match this to what the userform has and get the rowcount to
point to a cell reference C2 when Company Type = "Retail" And Company Name =
"Reece"

Once i can get that cell reference i can then use offset to place the output
from userform to the table

..Offset(RowCount, 3).Value = Me.Rev$.Value
..Offset(RowCount, 4).Value = Me.NoOfStores.Value
..Offset(RowCount, 5).Value = Me.State.Value