I have a database style spreadsheet that I use a lot and is stored on
our intranet.
I use a vlookup to find information about products in a database.
I look up the unique product name then choose the column that matches
a specific fieldname text.
It looks something like this:
=VLOOKUP(A2,ExternalRange,MATCH(F1,ExternalFieldna me,0),FALSE)

There are only two changing variables in this formula so I've tried to
create a custom function that already has the external database and
fieldname range built in, but to no avail. Anyone suggest help?

I guess that the custom function would only need to know the A2 and
the F1 bit in the example above.