Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 92
  • Last Modified:

Excel Formula and Link

I have an XLS with two tabs

Main
wBPS

in Main I want a formula in a column that will look at MAIN column A and wBPS column A and when there is a match I want the contents of that cell to be http://www.test.com?ID= and the value from wBPS column C.  When there is no match there should be nothing in the column
0
Matt Pinkston
Asked:
Matt Pinkston
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try with xlsx or xlsxm

=IFERROR(HYPERLINK(" http://www.test.com?ID="&VLOOKUP(A3,wBPS!A3:C5,3)),"")

or with xls

=IF(ISERROR(VLOOKUP(A3,wBPS!A3:C5,3)),"",HYPERLINK(" http://www.test.com?ID="&VLOOKUP(A3,wBPS!A3:C5,3)))


Regards
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now